Grid

The grid is the main display of information and allows you to zero in on the reference status of various objects.

To describe the grid let's go column by column from left to right.

Name - this is the name of the particular object but it also contains a graphic visually indicating the type of sql object it is.

Owner - the database owner of the object

Type - the type of the database object (i.e. view, table, default). This allows for sorting by type.

File Refs - this column provides the count of references to this object from files. 4 means that 4 client files reference this object

DB Refs - this column provides the count of references to this object from other database objects. 4 means that 4 other database objects reference this object.

Has Refs - this is a boolean field that indicates whether this object contains references to other database objects

Is Ref'd - this is another boolean field that indicates whether this object is referenced anywhere else in the database or client. If not, it is a candidate to be dropped.

You can double-click on any row to view the DDL script for that particular object. The following graphic is an example.